﻿CREATE TABLE [dbo].[Postleitzahl] (
    [EPLZ]         INT            NOT NULL,
    [LKZ]          NVARCHAR (3)   COLLATE Latin1_General_CI_AS CONSTRAINT [DF__Postleitzah__LKZ__4F47C5E3] DEFAULT ('A') NULL,
    [PLZ]          NVARCHAR (10)  COLLATE Latin1_General_CI_AS NULL,
    [Ort]          NVARCHAR (100) COLLATE Latin1_General_CI_AS NULL,
    [Zone]         SMALLINT       CONSTRAINT [DF__Postleitza__Zone__503BEA1C] DEFAULT ((0)) NULL,
    [Ortskennzahl] NVARCHAR (10)  COLLATE Latin1_General_CI_AS NULL,
    [Bundesland]   SMALLINT       CONSTRAINT [DF__Postleitz__Bunde__51300E55] DEFAULT ((0)) NULL,
    CONSTRAINT [aaaaaPostleitzahl_PK] PRIMARY KEY NONCLUSTERED ([EPLZ] ASC)
);




GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl';


GO
EXECUTE sp_addextendedproperty @name = N'DateCreated', @value = N'96-04-25 19:56:43', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl';


GO
EXECUTE sp_addextendedproperty @name = N'LastUpdated', @value = N'03-04-17 21:06:50', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl';


GO
EXECUTE sp_addextendedproperty @name = N'MS_OrderByOn', @value = N'True', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'Postleitzahl', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl';


GO
EXECUTE sp_addextendedproperty @name = N'RecordCount', @value = N'4658', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl';


GO
EXECUTE sp_addextendedproperty @name = N'Updatable', @value = N'True', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'17', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Eindeutige Postleitzahl', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'EPLZ', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'4', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'EPLZ', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Postleitzahl', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'4', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'LKZ';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'LKZ';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'2', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'LKZ';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'LKZ';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'LKZ';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'LKZ';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'600', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'LKZ';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'LKZ';


GO
EXECUTE sp_addextendedproperty @name = N'DefaultValue', @value = N'"A"', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'LKZ';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Landeskennzahl', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'LKZ';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'LKZ';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'LKZ', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'LKZ';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'2', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'LKZ';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'LKZ';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'3', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'LKZ';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'LKZ', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'LKZ';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Postleitzahl', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'LKZ';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'10', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'LKZ';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'PLZ';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'PLZ';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'2', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'PLZ';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'PLZ';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'PLZ';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'PLZ';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'PLZ';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'PLZ';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Postleitzahl', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'PLZ';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'PLZ';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'PLZ', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'PLZ';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'3', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'PLZ';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'PLZ';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'10', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'PLZ';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'PLZ', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'PLZ';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Postleitzahl', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'PLZ';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'10', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'PLZ';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ort';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ort';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'2', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ort';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ort';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ort';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ort';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'3180', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ort';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ort';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Ort', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ort';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ort';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'Ort', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ort';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'4', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ort';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ort';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'100', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ort';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'Ort', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ort';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Postleitzahl', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ort';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'10', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ort';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Zone';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Zone';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Zone';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Zone';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Zone';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Zone';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Zone';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Zone';


GO
EXECUTE sp_addextendedproperty @name = N'DefaultValue', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Zone';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DecimalPlaces', @value = N'255', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Zone';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Entfernungszone vom Standort', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Zone';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Zone';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'Zone', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Zone';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'5', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Zone';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Zone';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'2', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Zone';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'Zone', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Zone';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Postleitzahl', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Zone';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'3', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Zone';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ortskennzahl';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ortskennzahl';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'2', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ortskennzahl';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ortskennzahl';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ortskennzahl';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ortskennzahl';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ortskennzahl';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ortskennzahl';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Ortskennzahl (Ortsvorwahl)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ortskennzahl';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ortskennzahl';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'Ortskennzahl', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ortskennzahl';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'6', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ortskennzahl';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ortskennzahl';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'10', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ortskennzahl';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'Ortskennzahl', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ortskennzahl';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Postleitzahl', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ortskennzahl';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'10', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Ortskennzahl';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Bundesland';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Bundesland';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Bundesland';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Bundesland';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Bundesland';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Bundesland';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Bundesland';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Bundesland';


GO
EXECUTE sp_addextendedproperty @name = N'DefaultValue', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Bundesland';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DecimalPlaces', @value = N'255', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Bundesland';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Bundesland', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Bundesland';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Bundesland';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'Bundesland', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Bundesland';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'7', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Bundesland';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Bundesland';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'2', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Bundesland';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'Bundesland', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Bundesland';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Postleitzahl', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Bundesland';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'3', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Postleitzahl', @level2type = N'COLUMN', @level2name = N'Bundesland';

